You are here: Job and Form Set Rules Reference > JDT Rules Reference > XMLFileExtract > Mapping Fields

Mapping Fields

You can map the fields listed in the TRN_Fields control group using either offset/length, XPath, or a combination of both methods. In the RunMode control group, be sure to set these INI options:

Option

Description

XMLExtract

Enter Yes to tell the system you are using the XML file.

XMLFileExtract

Enter Yes to tell the system your extract file contains a list of pointers pointing to the XML file to be processed.

XMLFileExtractName

Use this option to tell the system how to find your XML file. Enter the method you use to point to your XML file. This should be exactly the same as how you would set up the rule parameter for the XMLFileExtract rule in your AFGJOB.JDTfile.

Here is an example:

< RunMode >

XMLExtract = Yes

XMLFileExtract = Yes

XMLFileExtractName = SCH=1,XML 20,60

Also set the TRN_Fields options as shown in this example:

< TRN_Fields >

Company = !/Forms/Key1

PolicyNum = !/Forms/PolicyNum

RunDate = !/Forms/RunDate;DM-4;D4

LOB = 30,15,N

Cust_Name = 46,30,N

The format for the options IN the TRN_Fields control group is:

(Field in the transaction DFD file) = XPath;Field Format

(Field in the transaction DFD file) = offset, length, Key;Field Format

An XML path search must begin with an exclamation mark (!). The exclamation mark is not part of the actual search routine. Do not specify whether a field is a key. The system does not support a multiple (search) keys with the XML implementation.

To selectively exclude transactions, use either an offset/SearchMask, the XPath, or a combination of the two in your exclude file. Here is an example:

!/Forms[PolicyType="OLD"]

20,ABC